Tiny Fluctuations, Big Impact: The Casimir Effect And Its Implications For Space And Beyond